tell my formula to use a rounded decimal

Question

Level 1

0 points

tell my formula to use a rounded decimal

How can I tell my formula to use the rounded number from a cell (cell has been formatted to round to the nearest one hundredth) instead of the actual value of the cell that has a running decimal?

iMac, iOS 8.4

Posted on Aug 25, 2015 6:28 AM

Reply

Answer 1

t quinn

Level 5

7,063 points

Aug 25, 2015 7:27 AM in response to kdavila4

Hi kdavila,

Use the function ROUND() and specify 2 for your digits. So if your formula was =A2x10, your new formula would be =ROUND(A2,2)x10. Round is a numeric function.

quinn

Reply